Synonyms that are in the dictionary are marked in green. Synonyms that are not in the dictionary are marked in red.
Antonyms that are in the dictionary are marked in green. Antonyms that are not in the dictionary are marked in red.
Pivot tables are mainly used to compile number data in cells, but they can also manipulate text data.
Source: https://www.computerworld.com/article/3686110/google-sheets-how-to-use-pivot-tables.html